for rs in `cat list.1|sort|uniq|grep -v TEMP$`;do echo $rs;rrs=`echo $rs|awk =F"." '{print $2}'`;echo $rrs;psql "dbname=$dbname_1 host=$host_1 port=$port_1 user=$user_1 password=$password_1"  -c "\copy (select * from $rs) to 110.txt with csv";dmfldr $user_2/'"$password_2"'@$host_2 table=$user_2.$rrs data=\'110.txt\' field_seperator=\',\' LOB_AS_VARCHAR=true append_option=1;done
